home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
PROGRAMM
/
DB_CLIPP
/
1984.ZIP
/
DFLIPPER.ZIP
/
DISK2.ZIP
/
DFLIPPER.DOC
< prev
Wrap
Text File
|
1989-09-03
|
45KB
|
1,053 lines
Copyright(C)1988
Shareware dFLIPPER dB ENGINE
by H.G.R.III Ltd.
Shareware dFLIPPER dB ENGINE
page 2
TABLE OF CONTENTS
TABLE OF CONTENTS 2
DISCLAIMER 2
INTRODUCTION 2
Engine: 2
STARTING 3
Installing. 3
USING 4
RUNNING OPTIONS 5
Fkey #1 help is always available in any option. 5
Option menus 7
SAMPLE FILES 11
MAILING LIST 11
CHECKDSB.DBF 11
CONTROL.DBF's 12
Optional CONTROL.DBF'S 12
ADDING 'FLIPPER' TO YOUR CUSTOM PROGRAM 13
Appendix 13
Browse 'WIDE' angle view with Calculator overlay examples: 13
CREATE.EXE 14
REGISTRATION 15
Other programs to 'MAKE YOUR DAY' 15
1. ShareWare BOWLING LEAGUE SECRETARY 15
2. Travel Agency - TRAVEL TICKET TRACKER 16
INDEX 16
DISCLAIMER
First, from a lawyer:
Dflipper Dynamic dBASE (tm); alias 'ENG.exe' and this and this
documentation are copyright 1988 by Howard G. Rice III. This
program and documentation are provided "as is" without warranty
of any kind, either expressed or implied, including but not
limited to the implied warranties of merchantability and fitness
for a particular purpose. The user of this program and
documentation agree to hold the author and/or distributor(s) of
this program and documentation harmless for any direct or
consequential damages resulting from its use.
Dflipper Dynamic dBASE (tm); alias dFLIPPER, file 'ENG.exe' is
copyrighted material.
Shareware dFLIPPER dB ENGINE
page 3
INTRODUCTION
Engine:
The first engine I heard of was Wayne Ratcliff's (the developer of
dBASE II and III) Emerald Bay Engine. He was giving a premature
demo to the Chicago Computer Society on MARCH 12 1987. There are
now many "engines" advertised in computer magazines. It seems the
term is used to indicate a utility rather than a complete system.
This is the case with dFLIPPER. While a program like dBASE IV has
more complete accessories it also sells in the $500 plus dollar
range. Programs like Wampum are available to Public Domain users
but there is still a desire to be able to rapidly 'flip' thru the
generated files to search for a record quickly.
Many accounting packages use the dBASE format. SBT, SOURCE ACCOUNT
MATE, LAKE VIEW and PROSPECT are just a few of the closed systems
which are compatible. Dac Easy is not one of these. Accounting
packages put you in a 'protected (closed) box' and make it
difficult to scan records at liberty. dFLIPPER will allow you
scan compatible accounting package file records. The engine
dFLIPPER is compatible with the above mentioned systems as well
as all dBASE III/IV compatible records. dBASE IV version 1 memo
fields are non-compatible at this time but will probably be with
version 1.1.
dFLIPPER includes several working sample file formats which allow
you to either use or modify to your needs.
STARTING
Installing.
Type the 'README.1st' file to check out disk drive installation.
The ENG.exe file can be called from any drive or subdirectory.
The default file name CONTROL is optional and you could just type
MYFILE INDEX MYINDX, INDEX2 for example to use an existing file
MYFILE plus the mentioned indexes.
The CONTROL file will allow relations across drives or
subdirectories and KEY FIELD INDEXes for FINDs instead of
LOCATES. A control file in each subdirectory with .DBF's will
allow easier call ups from other locations.
A new Summer 87 option allows the use of dBASE III+ indexes. Do:
Myfile INDEX myinde1, myinde2 etc. to use your file and indexes.
Shareware dFLIPPER dB ENGINE
page 4
- - - - - - - - - - - - - - - - - - - - - - - -
(C)copyright 1987 by HOWARD G. RICE III 09/04/88
MULTI FILE MASTER dbaseIII (tm) file editor / generator
Press any key to continue...
Database Files # Records Last Update Size
COMPCOMP.DBF 91 12/11/87 4608
COMPVAL.DBF 13 12/11/87 896
HOLD.DBF 7 12/11/87 640
CONTROL.DBF 1 08/19/88 776
DBCOMP.DBF 377 08/31/88 139122
146042 bytes in 5 files.
1290240 bytes remaining on drive.
TZIP.NDX SPEC.NDX
29696 bytes in 2 files.
NAME of File or Q to quit.rive.
ON Error hit Q. >: CONTROL
- - - - - - - - - - - - - - - - - -{sample screen}
EXAMPLE: (Assumes you have set PROMPT $P$G in your AUTOEXEC.BAT file.)
C:\YOURSUB>A:ENG If your dbf's on \yourdbf and ENG on A:
When you get to the file name prompt;
type over the CONTROL with YOURFILE (.DBF NOT NEEDED)
IF you know where you .dbf is, you can use the
DRIVE\DIRECTORY\FILENAME approach. A:>ENG then overtype CONTROL
with C:\yoursub\yourdbf
USING
- - - - - - - - - - - - - - - - - - - - - - - -
FILE CHECKDSB CHART DFHELP KEY = DATE [ Flip ]
Record 5/5
Field # NAME
1 DATE 05/23/89
2 NUMB
3 NAME ONE ITEM SOLD
4 CATEG TOUR
5 CHECK 0.00
6 XBOX 88
7 DEPOSIT 2000.00
8 BANK
9 COA
10 CBOX 1
11 B->CATEG TOUR
12 B->COA 5321
13 C->CBOX 1
14 C->DFHELP memo
MEMO's = @F9 or Z)oom or ^P)rint
Records: PgUp PgDw FLIP B)ottom T)op FKey1=Help @F2=Define @F5=Calculator
A)dd D)ele E)or<─┘Edit I)ndex M)enu N)ewKey P)rint Q)uit Re)scrn S)earch
W)ide
- - - - - - - - - - - - - - - - - - - {sample screen}
Shareware dFLIPPER dB ENGINE
page 5
A file that has records in it will come up looking like the above.
(one with no records added yet will show only the field numbers and
names)
RUNNING OPTIONS
Fkey #1 help is always available in any option.
Alt F5 for Calculator: (Thanks to Guenther Daubach of Germany) Works
like most desktop calculators. Use arrows to move to best location
then input numbers.
Escape to return to previous screen or X to insert figure into a
*EDITING* Numeric field. If you are in a Character field the
decimal spills over into the next field (fair warning). See
appendix.
ALT F2 (@F2) allows setting the function keys for repeat input such
as for a zip code or town when filling out a new league.
B) or T)op {hitting 'T'} will take you to the top or bottom of the
file.
If the first field is indexed, the top and bottom may *not* be the
first or last records entered.
A)dd will add a blank record to the file and automatically put you
into the edit mode. (Editing the new blank record)
E)diting a record is straight forward. The example below appears on
the lower part of the screen.
Up/Dwn arrow or <─┘ next Field: PgDn when done.
Fkeys:7=090488 8=312- 9=MR. 10=600
Insert key toggle will allow overwriting or inserting characters.
Backspace; del; home; end keys all work as expected (home
{beginning of field})
Up/Down arrows and the return key will take you to the previous or
next field.
PageDown (PgDn) tells the system you are done editing and finishes
the page (a real short cut if the first field is the only one
which needed editing).
Editing Mailing List differs because the screen looks like a
usual page but really from field one to the 'ZIP' code field is
one page and from the phone 'AREA' field to the last field is a
second page.
Two page downs are required to Goto next record.
D)elete will allow you delete the screen record. The following
message will appear and prompt you to make double sure.
DELETE this RECORD? Y/N N
S)EARCH will prompt for required search criterion. The key field is
shown at the top of screen. Searches are case sensitive.
SEARCH FOR WHAT Any Key? {example}
=>? ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
If the first field and file is indexed, you will search for 'Ric'
to find the first 'Ric' in the file.
Use the down arrow to flip thru the following records.
If there was no 'Ric' then you will prompted if you want to ADD a
new record.
Shareware dFLIPPER dB ENGINE
page 6
IF the file is not indexed or you are not in the 1st field KEY,
then: you can search for 'ice' to find 'Rice'.
I)ndex will create or overwrite an existing index.
Prompts for INDEX NAME and the criteria for the index. Example:
NAME: date
INDEX KEY: date
You could make a temporary index on zipcodes in order to print in
zip code order. If you edit or add records with a temporary
index in effect your original index will not match up to the
records any longer. When you tried to reload the file thru the
CONTROL file you would get an error message. To correct the
index error problem load the file direct with out the CONTROL
file and use I)ndex to reindex with the proper name and field
designator. Then call the file up with the CONTROL file. If
your index name matches the CONTROL files expected index name you
have cured the problem.
N)EW KEY will allow you to select a new search key field.
Just put in the field number to change to. If an index starts with
this field then searches will 'FINDS'.
0 FOR RECORD NUMBER
Enter Field # to use as SEARCH KEY 1
{example screen}
0 (zero) will allow record number search
Your last field number plus 1 will allow for dbase style multi-
field and multi-criterion searches. (ANY KEY SEARCH)
There are many good books to explain the power available here.
Check out a couple at your library or find them in a book
store.
ANY KEY SEARCH is error prone (as with dBASE) due to typo errors,
misuse of quotes etc. If an error is incurred, hit 'Q' or 'N'
for quit to save all previous editing or new records.
In ANY KEY search, if you are searching through a character field, you
would use quotes around your search value, such as 'JOHN'. If you are
going through a numeric field, such as a deposit, do not use quotes.
'JOHN'$UPPER(NAME) .AND. DEPOSIT>=100 (leave a space before and after
the period in .AND.)
The above example is just the tip of the iceberg of the power available in
the dBASE language. It would find NAME FIELD containing 'JOHN' anywhere
in the field with a deposit of more than or equal to $100.
P)RINT option will offer output options to go to:
P) printer
F) file by the name TEMP.TXT
S) or screen
'P' for printer; 'F'ile or 'S'creen -> {example display
Shareware dFLIPPER dB ENGINE
page 7
W)ide causes a Lotus like display of the file you are using.
Arrow Keys move the cursor in expected directions
Ctrl Arrows move the columns by one if the field number and sizes
exceed the screen width.
Ctrl PgUp/Dn goes to the TOP or BOTTOM record.
Ctrl Home/End go to first or last fields.
ENTER toggles to edit field mode and again the arrow keys function
as expected.
Insert, Delete, Backspace and normal keys edit the field.
Enter toggles back to BROWSE mode.
Escape returns back to single record view.
Z)oom or Alt F9.
Pops up the MINI EDITOR on the lower half of the screen and
displays any memo you might have for the screened record.
The sample file has a relational memo file linked to *. The memo's
contain additional information about dFLIPPER and can be viewed
by changing memo # and then doing a 'Z'oom command.
The memo fields are non-volatile. They do not expand
disproportional to the memo contents.
F1 help will display speed keys. Memo editing is done in Word Star
format with end of line and end of paragraph high bit characters
which do not show thru the editor. Reformat paragraphs with
control B.
M)ENU pulls up the Option menu.
╔════════════════════════════════════════════════════════════
║
║ Option menus {example}
║
╚════════════════════════════════════════════════════════════
│
│ Return to existing file [0]
│ Get new file [1]
│ Dos commands {change directory etc} [2]
│ Look at last 20 records entered [3]
│ Total CHECKS and DEPOSITS for PERIOD [4]
│ Out-standing check/deposits + ReBal [5]
│ Total remaining balance [6]
│
│ Choice or [0] TO EXIT 0
└────────────────────────────────────────────────────────────
- - - - - - - - - - - - - - - - - -{sample screen}
Option menus
Return to existing file [0]
Takes you back to the file you where working on.
Get new file [1]
Goes back to 'Flipper's' original intro menu. Prompts for new file
name. Overwrite the CONTROL with any legal DBF file name. (See
starting)
Dos commands {change directory etc} [2]
See following chapter on Dos command menu.
Shareware dFLIPPER dB ENGINE
page 8
Total CHECKS and DEPOSITS for PERIOD [4] {disbursements only}
Period disbursements are summed. Use 88 for outstanding and proper
number of month when consolidating bank statement.
Use N)ew field (Xbox) and S)earch for 88 when bank statements
come in. Edit Xbox to statements month and hit: Enter or Down
Arrow to get the next record with an 88.
Once consolidated, the months bank statement should equal the
checks and deposits for this option.
Out-standing check/deposits + ReBal [5] {disbursements only}
Will allow display or printing of all outstanding checks or
deposits and then show the remaining balance.
Total remaining balance [6] {disbursements only}
Will add all deposits minus checks with an Xbox number larger than
88 to show the remaining balance.
Choice or [0] TO EXIT (exits back to file)
- - - - - - - - - - - - - - - - - - - - - - - -
Dos commands {change directory etc} [2]
- - - - - - - - - - - - - - - - - - - - - - - -
Dos and DBase commands. On error QUIT or NO for retry!
Dos commands will require access to command.com.!
SEARCH KEY may effect order if indexed.
Unfiltered records effected only.
Blank xx will abort!
EXAMPLE DATE>CTOD('01/01/88')
1)SET dB DEFAULT 2)SET PATH TO d:\xx 3)FULL DIRECTORY <S>
4)DOS SHELL 5)ReIndex files 6)LIST/VIEW xx
7)COPY TO TEMP.FLE(DELIMITED) FOR xx CONDITION
8)COPY TO TEMP.DBF for xx 9)APPEND FROM xx FOR yy
10)TOTAL ON xx FIELD yy TO TEMP.DBF 11)SUM xx FOR yy
12)REPLACE all xx WITH yy 13)SET ORDER TO x#
14)SET FILTER TO xx 15)DELETE FOR xx 16)RECALL FOR xx
17)REPORT FORM xx HEADING yy 18)LABEL xx FOR yy
19)rePACK DBF 20)*ZAP*everything
21)TOGGLE READONLY 22)Set Field list
99)Show inkey (programmers option)
0)exit choice?
- - - - - - - - - - - - - - - - - - - - -{example}
1)CHANGE DRIVES
This will allow getting a directory of area you would like to get a
new file on.
2)SET PATH TO ?:\xx
Same as above for subdirectories.
Shareware dFLIPPER dB ENGINE
page 9
3)FULL DIRECTORY <S>
Will show a complete Dos style directory of logged area.
Logged areais a dreadful but accepted name to describe the
current Dos or program Drive/Subdirectory. (Log on)
4)DOS SHELL
Will allow you to temporarily exit to dos. You are actually
sitting on top of Flipper and the available memory is diminished
greatly by Flipper.
Type in EXIT to return to Flipper. It is easy to forget to do
this. Hence Save edited records first is automatically invoked
before you can enter the Dos Options Menu.
5)ReIndex files
Very useful if someone edits the ZIP CODE file and messes up the
indexes used in the MAILER file. (Be careful when re-indexing
someone else's existing files. You could overwrite a completely
different index with the name you give your new index.)
The following options require more than a passing thought. Many good
dBASE books will elaborate in great detail.
All use the same input format while using the input for the
individual intended purpose. Most will copy files to a
'TEMP.DBF' and *WILL OVERWRITE* and existing TEMP.DBF.
{example prompt}
INPUT xxx AND/OR yyyy CONDITION WILL *DO* ALL not filtered records!
xxx COND ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
yyy COND ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
Failure to use the 'xxx' condition and leave it blank will cancel
the command order. Not all options will use the 'yyy' added
filter. Putting something here when not needed will just be
disregarded.
6)LIST/VIEW xx
Like the dos TYPE command. Look at files and scan or even edit
them. Y/N option on saving any changes. You must know the file
location and name in order to insert name into the 'xx' prompt
(dflipper.doc would view this file).
Do not edit .dbf or .dbt files with any text editor. You can
scan them but be sure not to save afterwards or they will be
forever corrupted.
7)COPY TO TEMP.FLE(DELIMITED) FOR xx CONDITION
Will copy all included records to a TEMP.FLE in ASCII FORMAT for
use with aword processor's MERGE program or any other purpose you
might think of. Use your word processor to SEARCH AND REPLACE
needed characters ("," with !,!) for example.
The format is MsWord compatible. To pull just one record's
information into a letter is easier to just word processor
MERGE TEMP.FLE and replace all "," with ^p (or your WP's mark
for new-paragraph). Then delete the not wanted fields.
8)COPY TO TEMP.DBF
Makes a new file called TEMP.DBF and can be renamed from the Dos
prompt to anything you like.
Setting a filter first will limit the file records included.
Example: SET FILTER TO ALL NAME = 'RICE'; will copy only
records which name is equal to RICE to TEMP.DBF.
(Remember to reset filter to {blank}) to use all original records
when going back to original records.
Shareware dFLIPPER dB ENGINE
page 10
9)APPEND FROM xx FOR yy
Allows coping files from another DBF file. Fields which have same
name only will be copied. Set filter with FOR condition.
10)TOTAL ON xx FIELDS yy TO TEMP.DBF
Creates a temp.dbf with one record per change in the 'ON xxFIELD'.
FIELDS yy is the field list. Blank will copy all fields.
Total on indexed field only.
Example: TOTAL ON categ FIELDS name, categ, check, deposit
will create a record for each different categ with the mentioned
fields and check and deposits will be grand totals.
11)SUM xx FOR yy
Example: SUM deposit FOR categ ='SALES'
12)REPLACE all xx WITH yy
THIS SUCKER can ruin you. BE CAREFUL!
REPLACE ALL deposit WITH 0 will do just that! Any non filter
record will have a 0 in place of what ever was there.
REPLACE all COA WITH &B->COA will cause a macro replacement of the
main files COA to be replaced with the related files COA.
The '&' is the key and can be used to replace one field with
another fields contents. CATEG with &COA would replace
category with main files COA contents.
Macro field substitution was the one hangup causing the need to
use dBASE or Fox. I find I now can almost always do with with
out other programs.
13)SET ORDER TO x#
For advanced dbase users. Check out the many dBASE convention
books available.
14)SET FILTER TO xx
Example: SET FILTER TO categ='OFF' will only consider records with
the category starting with 'OFF' and include OFFICE as well as
OFF/MAIL (do not use quotes in actual data base field but you
must use them for the search or requests).
15)DELETE FOR xx *CAREFUL* Will delete for any condition given and
effect only unfiltered records.
16)RECALL FOR xx Will recall all deleted records which may or may
not be what you really wanted. Consider changing a special field
for a mass delete to 'Y' so you could trace before and after
records involved with a second delete.
17)REPORT FORM xx HEADING yy
and
18)LABEL xx FOR yy will allow you to use existing report forms
created from other PROGRAMS (dBASE III etc.).
19)rePACK DBF will squeeze out existing deleted records for ever!.
20)*ZAP*everything Will give one warning and on 'Y' will delete and
pack all records. No recalling these records.
21)TOGGLE READONLY A new option to allow control over letting
someone use your files for information while not letting them edit
any of them.
(That one person who can mess up a file in one second) every office
has one and sometimes it is the boss.
22)Set Field list will allow controlling the fields shown on the
regular or wide screen.
The option starts up with NO FIELDS SHOWING! You must check off
the ones you want to show. Fkey 3 will mark all fields and fkey
4 will *unmark all fields for display.
Shareware dFLIPPER dB ENGINE
page 11
SAMPLE FILES
MAILING LIST
- - - - - - - - - - - - - - - - - - - - - - - -
Field # NAME {example}
1 SPEC CIE SYSTEMS INC.
2 NAME CITOH CIE
3 FNAME
4 ADDR 2515 McCabe Way
5 ZIP 92714
6 AREA 800-437
7 PHONE 2341
8 DATE C.ITOH ELEC. INC. TOHO SEIMEI BLDG 27tH
9 NOTE1 2-51-1 SHIBUYA TOKYO 150 JAPAN
10 NOTE2 CITOH PRINTER MANUFACTURER REPAIR
11 B->Zip 92714
12 B->AREA 800-437
13 B->TWN Irvine
14 B->STATE CA
- - - - - - - - - - - - - - - - - -{sample screen}
The included Mailing List file is indexed on SPECial field and used
for company name. To search an indexed key field you must match
from the first character on to your optional length of criterion.
RI to find the first company name which begins with RI (all
dFLIPPER searches are Case sensitive). Down arrow or return keys
to skip to the next record. You can skip right on down to the
bottom of the indexed file.
'MAILER.DBF' ZIP code (mailzip.ndx) field is indexed to maintain
the mailzip.ndx. You automatically maintaining indexes with this
setup!
'LIST.DBF' is linked to the 'MAILER.DBF' (SET RELATION TO zip INTO
mailer {dBASE command}) and will bring up the 'look-up files'
town, state and area phone number. If none is found in the
'look-up' file then the fields are obviously blank.
In order to rename or create a new 'LIST' file you must also use a
copy of the CONTROL file and edit it to your new file name and
location. Do not rename the MAILER file because it's name being
present triggers a flag to setup the display of the town and
state.
Editing or Adding new records effect the 'look-up'. Only editing
the AREA code will add the AREA code to the 'look-up'.
If errors in zip codes develop (NOT FOUND or WRONG ZIP) then
someone edited the MAILER(ZIP) file direct and messed up the
indexes. Just go to M)enu option and RE-INDEX.
CHECKDSB.DBF
Is an example of a check book manager. Any name with DSB in it will
cause the disbursement options to become available. (MYDSB89.dbf)
Shareware dFLIPPER dB ENGINE
page 12
Use 0 in XBOX for starting balance. Use the default 88 for
outstanding checks or deposits. Use numbers higher than 89 to
not be included in the balance (NOSHOW cash for example).
Replace 88 with the month number when re-consolidating the bank
statement. WIDE option is very helpful when consolidating bank
statements. Just pan down the xbox column to change 88 to
current month. Use 'SET FILTER TO xbox=88' but remember to 'SET
FILTER TO <BLANK>' before checking totals. Then use the menu
option to add all checks and/or deposits for the giving period.
Edit or Wide angle view with filters until debits and credits
match the checks and deposits on statement.
Index on CATEG(ory) and use menu option TOTAL ON categ TO TEMP to
get a summary of category expenses and receipts (Use new file
option and get TEMP.dbf to work with the summary file).
CONTROL.DBF's
Structure for database: B:control.dbf
Number of data records: 1
# Field Name Type Width comments
1 CSET1 Character 30 Sets 1st default drive and subdirectory
2 DB1 Character 70 Data base and optional index names
3 NX1 Logical 1 True locks main index
4 CSET2 Character 30 Sets 2nd drive and subdir
5 DB2 Character 70 Second data base for relational set up
6 CRELATE2 Character 30 CATEG CHART sets relation into chart.dbf
Use all caps in this field. All fields in
the chart.dbf will be preceded with a B->.
7 CSET3 Character 30 Sets 3rd drive etc.
8 DB3 Character 70 Third dbf if any.
9 CRELATE3 Character 30 CBOX DFHELP sets relation into dfhelp.dbf
in example disbursement file. All fields
will have B-> in front of their name.
10 READONLY Logical 1 TRUE here would never allow editing or
adding new records.
11 KY8 Character 20 This fields can be set to your
12 KY9 Character 20 specifications to change F.Key settings.
13 KY10 Character 20
** Total ** 423
Optional CONTROL.DBF'S
You can always over type the default CONTROL name with your file name
and indexes if any. Indexes will be maintained (updated) and
search keys will automatically detect index condition and select
FIND or LOCATE FOR command.
The optional control has multiple purpose. Most important, it allows
you change disks/subdirectories just by:
'NEW_DISK:\NEW_SUB\CONTROL.
Shareware dFLIPPER dB ENGINE
page 13
Not only does Control.dbf allow setting the default drive and
subdirectory but it also used to set up multiple file relations,
define function keys and override auto index detection. To have
a CONTROL.DBF in every subdirectory you keep .DBF's in is a time
saver for switching between disks, subdirectories and DBF files.
You can copy a control file into any subdirectory or disk and edit
CONTROL.DBF. You can, as in the demo, have multiple control
files with modified names in one subdirectory. You can only edit
a control file with dFLIPPER if it is named by placing a 'E' in
front of the name (ECONTROL.DBF or ECONT88.DBF for example). You
must be in the subdirectory before calling up dFLIPPER in order
to edit a CONTROL file.
ADDING 'FLIPPER' TO YOUR CUSTOM PROGRAM
dFlipper can be added wholly or in part to your custom application.
It is only a matter of a short front end program in your custom
program to call it up. The module does not contain the
INTRODUCTION or color selection start up and is very small 25+K in
size including the self contained help.
Example program code:
Use Your file index yourinde, u2inde
DO dflipper
It is also possible to use flipper with your screen formats and to
eliminate the M)enu option for security. Flipper is modular and
custom requests can be met on a direct basis.
Call for quotes.
Appendix
Browse 'WIDE' angle view with Calculator overlay examples:
Record 55/74
BW_NO NAME TM_NO SEX_FML SUBST TTPIN TTGM HDCP AVRG HGM
══════ ════════════════════ ═════ ═════╔══════════════════════════════╗═══
51 AXELROID DON 7 ╟───────────────────────┬─────┐║207
56 SCHARN TOD 5 ║ 1243 │ / │║182
57 PYLE ANDY 3 ╟─────┬─────┬─────┬─────┼─────┤║213
58 PYLE GOMMER 2 ║ Esc │ X │ BSp │ C │ │║145
59 WICK LORY 2 ╟─────┼─────┼─────┼─────┼─────┤║144
60 COLLI JIM 10 ║ 7 │ 8 │ 9 │ + │ │║211
61 WASHINGTON TIM 7 ╟─────┼─────┼─────┼─────┼─────┤║124
62 MORANS HERRY 7 ║ 4 │ 5 │ 6 │ - │ │║188
63 BATS NICK 9 ╟─────┼─────┼─────┼─────┼─────┤║198
64 BATSEN CINDY 9 ║ 1 │ 2 │ 3 │ * │V=+/-│║159
65 MILLER RICH 8 ╟─────┼─────┼─────┼─────┼─────┤║172
66 BOVIN TENNA 4 ║ 0 │ . │ │ / │=|Ret│║144
67 KELLER HELLEN 10 ╚═════╧═════╧═════╧═════╧═════╧╝141
68 MARVIN AURA 8 1 0 1243 9 52 138.11 178
69 JAW MIKE 8 0 0 1053 6 21 175.50 202
70 LOGAN LAURA 3 1 0 759 6 62 126.50 161
71 LYNCH HIGH 7 1 0 730 6 67 121.67 148
72 MALK MILK 2 0 0 1334 9 44 148.22 181
73 BRONSON STEVEN 6 1 0 445 3 44 148.33 174
══════════════════════════════════════════════════════════════════════════
Esc to exit; PgUp/Dn Ctrl=Move; Enter toggle edit etc.
- - - - - - - - - - - - - - - - - -{sample screen}
Shareware dFLIPPER dB ENGINE
page 14
(Use search;══/replace;-- etc. for non-IBM printers if above
screen is scrambled on printout.)
The above example shows the 'Wide angle Browse and Calculator'
option, both activated simultaneously. You need to hit Esc twice
to get back to the normal edit mode from this position.
The calculator can be moved about the screen when it is first pulled
up. Just use the arrow keys or FKey1 for help. Hitting any number
or Enter key will start it working.
The above example shows bowler #68's TTPIN count on the screen and
the divide-by sign which means you could now input the number of
games (9) and hit enter for the answer. 'V' toggles the sign from
plus or minus. 'X' would take you back to the field you invoked
the calculator from and bring the number with it. If you
accidentally mess up the following field with digit spill over you
can hit Ctrl U to undo; the mistake for the present field only.
Editing fields in Browse require hitting return once to allow edit of
field; insert or overwrite; enter to go to next field. Ctrl
Home=1st field; Ctrl End=last field. Editing here is slower but in
some cases the view makes up for the inconvenience.
CREATE.EXE
Is a stand alone file to create new dbf's or modify structure of an
existing data base file. You must quit dFLIPPER in order to use
create.exe.
CREATE exist.dbf will destroy old records in the file 'exist.dbf'!
Copy the file to a new name like fileold.dbf before modifying your
original file.
EXample: Dos> COPY exist.* fileold.* This will copy memo fields
DBT files also.
'CREATE file.dbf' is the command to create the new empty 'file.dbf'
or modify an existing 'file.dbf'.
Fkey #1 will give two help screens with commands on the second
screen. Just read and proceed slowly and logically.
Field types are toggled with the space bar. Numerical fields allow
for a decimal place allotment. 1234.56 would require a width of 7
to allow for the decimal point and the two decimal places.
It is really easy to understand after a couple of practice tries.
Shareware dFLIPPER dB ENGINE
page 15
REGISTRATION
Registered owners will receive: Newest version of dFLIPPER; full doc-
umentation; CREATE, FORMAT and LABEL files which allow unlimited
expansion and customization of dFLIPPER files and reports.
Additional .LBL AND .FRM file examples and additional hints on
useage of FORMAT AND LABLE programs.
Registration costs $45.00 or $10.00 for latest unregistered copy.
Send check OR inquiry to:
INCLUDE YOUR
H.G.R.III Ltd. NAME:___________________________
421 Greenbay Rd. ADDRESS:___________________________
Highland Park, Il. 60035 TwnSttZip:___________________________
BIX: hrice Compuserve: 72007,1757
Other programs to 'MAKE YOUR DAY'
1. ShareWare BOWLING LEAGUE SECRETARY
Got a PC? Be the league secretary. Quick and EASY and FLEXIBLE.
Just enter team number once per team:
bowler number once per bowler:
bowler's three games per night and get:
Automatic team positions; new handicaps; averages etc. (Allows for
extra bowlers or temporary bowler team switches.)
The following list a few of the features of the secretarial service.
The program can be run on a single disk drive PC with 516K memory.
Bowling league secretary will:
Keep records for a split league (A/B divisions)
Keep records for a split season.
Keep records for mixed leagues and/or substitutes.
Can be started mid season.
Will print out:
Team pairing and score sheets for bowlers for each night.
Status sheet for league teams and bowlers per week.
Bowler handicaps and averages even with out any games bowled.
Performance sheets for bowlers at end of year.
Bowler/team list.
Shareware dFLIPPER dB ENGINE
page 16
2. Travel Agency - TRAVEL TICKET TRACKER (Custom orders only.)
(TM)
EASIER TRAVEL TICKET TRACKER (TTT)
THAN by HOWARD G. RICE III (312)433-3931
123 or (312)433-0070
Weekly: Arc report.
*Builds files for: Tracking debit memos, refunds, recalls, commissions,
vendors, office cash and much more.
*Agent Commission checker.
*Instant commission statements; checks duplicate submissions, refunds and
debits against agent.
*Customer files/Account receivable/customer tracker.
*Instant individual or all customer receivable or activity reports. Keep
those commercial accounts happy with easy detailed reports.
*Use for word processors Mail-Merge letters on 'TICKLE FIELD'; maintain
credit card numbers, preferences etc. (MsSaber etc.)
*Vendor files maintain address and phone numbers for brochure orders
and/or current information on total sales, receivables and payables.
*Search/edit: Ticket, invoice numbers, customer name or most criterion for
editing or auditing.
*Reports: Cash, Credit, Arc, Profit reports by the week, month or all.
*Backroom Bookkeeper helper. Debit memo tracer.
*Quick ARC error detection.
(Call for quote on TTT.)
INDEX
'TEMP.DBF' 9
Add the AREA code to the 'look-up' 11
ASCII FORMAT 9
Correct the index error problem 6
Create a new 'LIST' 11
CREATE exist.dbf will destroy old records 14
Create or overwrite an existing index 6
Ctrl U to undo 14
Do not edit .dbf or .dbt files with any text editor 9
E)diting a record 5
Edit CONTROL.DBF 13
Editing Mailing List 5
If an error 6
Logged area 9
Macro field substitution 10
Next record 11
NOT FOUND or WRONG ZIP 11
Period disbursements 8
Quit dFLIPPER in order to use create.exe 14
Rename the MAILER file 11
Save edited records first 9
Unexpected order of records 8
Use quotes 10
Word processor's MERGE program 9